School of Computer Engineeringcoretheory
DATABASE SYSTEMS
CSS 2201
Syllabus
- 01Database-System Applications
- 02Database Languages
- 03Relational Databases
- 04Database Design
- 05Data Storage and Querying
- 06Database Architecture
- 07Database Schemas
- 08Keys
- 09File Organization
- 10Organization of Records in Files
- 11Relational Query Languages
- 12Relational Operations
- 13SQL Data Definition
- 14SQL Data Types and Schemas
- 15Integrity Constraints
- 16Set Operations
- 17Aggregate Functions
- 18Overview of SQL Query Language
- 19Basic Structure of SQL Queries
- 20Join Expressions
- 21Overview of Query Processing
- 22Measure of Query Cost
- 23Selection Operation
- 24Sorting
- 25Join Operation
- 26Other Operations
- 27Overview of the Design Process
- 28The Entity-Relationship Model
- 29Extended E-R Features
- 30Reduction to Relational Schemas
- 31Features of Good Relational Design
- 32Atomic Domains and Normalization
- 33Transaction Concept
- 34Failure Classification
- 35Storage, Recovery and Atomicity
- 36Recovery algorithm
References
- Silberschatz, Korth, Sudarshan, Database System Concepts, (7e), McGrawHill, New York, 2011.
- Pramod J Sadalage, Martin Fowler, NoSQL Distilled, Addison-Wesley, 2013.
- Ramez Elmasri and Shamkant Navathe, Durvasula V L N Somayajulu, Shyam K Gupta, Fundamentals of Database Systems, (6e), Pearson Education, United States of America, 2011.
- Thomas Connolly, Carolyn Begg, Database Systems – A Practical Approach to Design, Implementation and Management, (4e), Pearson Education, England, 2005.
- Peter Rob, Carlos Coronel, Database Systems–Design, Implementation and Management, (10e), Course Technology, Boston, 2013.
- https://onlinecourses.nptel.ac.in/noc25_cs40/preview Introduction to Database Systems
Credits Structure
3Lecture
1Tutorial
0Practical
4Total